SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019547 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019547 [ RunTime:0.002689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399989,731516,693564,559367,254607,984553,376791,394606,193830,510109,235584,999835,962176,762410,284068,616099,282780,206835,642703,514439,781127,41391,40546,328578,163078,397013,459364,291467,578903,378722,396383,524518,487392,642508,177998,552818,743614,946571,472701,1584,859007,602442,1003072,11131,482993,411993,28076,1026961,851309,11083,407992,859564,725880,562366,207053,850335,534565,300311,738791,370239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]