SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 936180 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 936180 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002746,265428,902788,1013492,356116,835689,458987,105316,23106,23418,119336,562518,92624,531103,248205,904707,746298,672899,178138,505337,385143,31924,826230,609539,391289,1003535,252683,1017975,461290,727730,303780,673820,11790,867184,990763,309787,768852,371903,530825,1047536,833467,743651,415110,458948,109288,118487,47277,752314,636138,435781,311820,341906,776151,273839,38422,642610,846339,1014956,89147,520533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 936180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 936180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]