SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406079 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406079 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030066,34370,420106,467563,579524,362208,205161,330243,206471,817319,274325,293705,329981,222396,671290,442678,93276,811353,323631,963110,756134,551655,1019534,630886,984517,469722,721068,825456,613702,699644,17258,902279,332689,659908,213521,772058,329486,809307,973282,483994,933112,793719,940792,1040221,429643,707040,397377,714552,1038251,368953,528863,277751,57032,280086,289570,446908,715874,846159,908873,41885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]