SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506010 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506010 [ RunTime:0.003909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141098,946168,169028,937365,776151,917273,1034768,888870,679506,832750,91880,926243,1014971,230915,118208,458122,666999,458798,406467,237654,979550,588464,336745,815520,644230,36645,449004,697300,739539,450993,263706,8020,522404,1026600,394373,218033,1004817,338211,184362,258976,643584,948414,954157,408499,500792,222577,98584,626865,446114,46516,926117,645390,384452,458418,63958,818581,507056,981187,614944,465856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]