SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262208 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262208 [ RunTime:0.002241s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586464,436825,921036,268721,851097,396952,748115,865711,640283,220736,329625,63003,213427,39595,70166,708854,65370,666770,833002,162826,822100,191958,191130,690028,759151,816534,973987,906939,983711,818619,348714,842686,423479,20581,40145,597790,833738,814616,4254,635316,397334,411466,709814,409283,775014,678125,77709,229019,1040323,26500,747685,960782,242083,437903,495516,324308,421528,925260,1046035,99252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]