SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428841 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428841 [ RunTime:0.003057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41189,568081,1005659,1023105,278084,914278,724001,1011943,24806,563007,864213,744183,511384,523583,1046935,400017,315216,294236,503606,22522,577968,262800,787597,505153,759365,381755,454341,592931,598366,210972,349181,482544,844553,588721,89256,960869,191253,541744,462778,516906,66350,135321,262197,446669,302884,708972,188543,841628,882150,334790,578976,379956,544892,690097,176124,1015911,9240,1001491,706685,836336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]