SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440688 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440688 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476093,870828,264475,249421,955188,704033,191505,828459,937385,141034,972603,782992,983784,891972,942739,177214,403593,484573,746837,447363,521394,980416,827882,335286,731233,128804,711836,435627,412438,298212,452796,664483,658966,951646,285378,411418,52816,30216,579410,591342,229942,120866,133661,145437,53255,481757,1011684,953563,178201,676673,776998,878777,979108,825876,453589,238828,836745,47845,418886,535835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]