SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407482 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407482 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836254,239872,1037002,916531,1001094,332847,41261,449821,774965,858190,202851,364109,706122,752138,649899,376665,499717,304535,145990,979633,170297,333423,248756,926771,688298,513720,263555,244452,391358,135298,882010,884498,450763,271127,60703,991453,397901,516764,464803,250321,55265,20570,611066,134328,152849,993758,653647,187228,994727,623525,50829,1031594,447679,1017282,37633,620974,343094,198485,799971,593456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]