SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041660 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041660 [ RunTime:0.001542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446939,984942,507961,666668,854042,319330,160217,877648,229503,447481,897002,527153,540193,530288,717908,520108,564769,439713,401956,232217,933169,199094,699466,647293,427552,387520,1001978,1036748,803128,76900,532008,839925,964092,990756,355519,588630,142302,812888,672956,836184,1038845,263096,387407,484275,649217,791996,912450,146009,171238,824922,703245,988198,272462,14150,378443,273637,208747,896885,245383,389965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]