SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408412 LIMIT 1 [ RunTime:0.001908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408412 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364869,820749,842074,737789,920748,113381,512870,243598,701405,494798,721878,962598,655420,987714,413024,795098,527622,741167,357703,698190,500793,792447,255540,371595,541242,665097,702962,1046106,922841,948383,3596,824006,321675,799077,955912,409693,1039325,47741,100914,537459,943947,737623,475077,872311,999372,420212,865696,940747,703414,1046104,161948,215910,476092,362068,177922,481729,583593,657965,666540,1025995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]