SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413715 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413715 [ RunTime:0.003038s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249534,977497,355744,920125,940676,709429,714580,1006721,574776,24253,623417,173951,807357,512332,965690,710832,722615,844845,157350,878182,259367,101456,92,480879,494968,574677,814984,1034943,64457,490598,82601,802328,314487,790683,1021249,691154,782167,389201,254190,1044217,182285,47889,492354,898053,708623,1016461,600415,992207,580620,607556,535190,290349,454297,206703,620808,982632,966255,138101,974535,466623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]