SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017486 LIMIT 1 [ RunTime:0.002806s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017486 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599623,238575,686338,365717,592081,8385,539818,74317,623614,1021197,99047,447191,218794,172959,322376,896723,232096,486919,278840,565269,433198,183887,917177,1025960,646053,586132,474728,777898,272365,700409,651844,540145,424913,330060,383254,274976,906265,232310,989827,841024,509839,951365,271329,417765,651584,39189,732257,96601,566290,695116,898473,519066,912322,114597,39348,203467,176656,33763,636930,519225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017486 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017486 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002819s ]