SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330056 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330056 [ RunTime:0.002404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448597,530470,203114,76721,430876,608081,1452,527194,604567,398187,374309,804533,111193,375358,379900,398305,253208,764229,564784,832798,895833,219968,1027496,103612,114873,481276,694876,1001467,443673,616323,982718,540538,116413,130395,431339,540482,347958,596021,380690,371440,705939,491409,843378,396694,826227,493244,23477,322404,1019941,986286,333761,244876,332413,765743,924989,148262,632384,103505,173315,199651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]