SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241216 LIMIT 1 [ RunTime:0.002505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241216 [ RunTime:0.003286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270050,143936,1018310,603404,168270,1020943,355092,398576,911020,541672,399202,1028093,832812,718550,225687,1024063,313676,453358,2298,802283,315604,28823,612065,206011,936972,85698,596216,344016,1026023,364791,407747,199748,611214,301585,409279,967805,368044,544960,21659,504424,534130,183429,462242,83674,771178,361400,862178,71551,955332,45323,948061,653590,371896,172053,485073,404118,580794,803338,560938,173007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004414s ]