SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 22513 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 22513 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509818,417840,222437,6769,475183,481385,900426,708718,808211,177999,737555,1036459,687465,640845,967394,28808,57743,799002,123302,532438,922963,569030,401406,1035265,371441,190929,189216,418269,597449,583605,67270,364168,806833,946421,786884,294834,324614,356868,688240,1005054,1044333,706548,941009,362185,672192,770515,598502,461567,623495,295959,516069,676930,85427,56605,603229,273429,419650,727812,576235,12641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 22513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 22513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001285s ]