SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509371 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509371 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280823,1000391,171749,830645,121695,688972,142548,973498,985946,794411,720886,1029395,150539,692211,924478,976117,106072,720462,238872,86262,834542,545521,435049,2111,720438,50800,824709,798329,935569,987581,491840,596453,476950,946583,267349,172393,761672,703054,376665,427449,782297,868769,504693,824617,141818,784996,622800,175186,933678,354346,1023656,575953,950150,850547,239168,54441,127237,865002,1024338,180172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]