SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103244 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103244 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410148,396904,965432,395163,938616,296447,899097,462762,255845,853500,26471,838651,66502,691603,594027,472057,159027,260471,20671,10119,586278,354818,30866,139574,338706,1014039,483857,330616,860181,71275,103009,139920,252998,608238,329311,590450,460429,229807,464726,395685,923549,437750,745289,750064,303267,569330,709551,116057,501553,655534,951144,399189,411928,604437,272485,852115,1020543,761892,183333,431268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]