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` = 370043 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370043 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192977,650481,898264,71682,756667,92553,639440,611596,305804,754444,23963,584800,583624,516881,318898,638986,195574,534701,592795,995844,174992,446666,965860,97977,793590,971795,323146,977146,875743,248549,264256,320501,804972,116629,262646,984859,436245,242007,435134,49908,675782,268745,110063,759357,578709,821369,233914,848001,49302,562451,565121,985007,662678,962420,232911,493940,211917,735145,708039,492324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]