SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578040 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578040 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460469,141903,497573,923436,69287,953812,683245,236385,314768,263899,1045078,637676,529866,428952,414023,431092,417604,5279,479258,816308,695397,12775,366838,881148,615433,958199,484243,225056,111841,341378,490953,982637,265061,305046,623001,208986,15293,441728,465752,707309,238273,325494,581229,678644,460432,45769,462486,765773,614315,837475,920690,9078,100088,669113,689232,909965,402551,1012219,590671,602753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]