SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 917181 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 917181 [ RunTime:0.001984s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529486,105898,228149,145191,903457,235064,860398,120751,305162,673503,1043066,98751,116342,492340,856952,672947,596448,596897,239287,597716,37589,120091,467058,737766,200779,651020,935608,730708,620614,37038,656588,100198,530163,775787,962778,137065,628093,623444,731685,62963,117632,798762,582214,42423,974844,652133,197044,1000750,388330,617233,613632,875455,902760,924661,340679,220818,1008479,111088,692810,694872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 917181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 917181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]