SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 18418 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 18418 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233019,842858,144851,21923,501691,143477,625498,321726,1034745,318965,870752,12565,94003,875277,519961,176583,19128,974175,434082,715068,995522,1023053,59000,88567,754091,651983,480579,177566,446854,76945,417781,929118,382413,930403,901398,448097,194965,524035,866219,898336,120982,557376,824135,1027003,99284,742429,190130,1030466,550946,149957,363078,856083,248444,292966,702749,62459,7101,215665,48503,152737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 18418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 18418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]