SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448161 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448161 [ RunTime:0.002251s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530473,705668,472108,520812,946881,336605,547464,544775,552032,693300,861517,406955,408471,892538,73903,141996,357218,136735,445018,161867,536705,1007045,605833,17361,625346,491178,768704,405730,355825,992750,47708,1034003,523776,755643,874177,775416,547842,843927,64098,84797,758238,851102,790546,64186,360049,21335,688767,267559,858118,216267,27676,833919,816035,66539,137738,250585,766187,252623,859207,188197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]