SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469041 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469041 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013164,797746,315476,740971,990215,644177,856889,105147,299841,687962,279907,982122,984616,14980,954893,539098,589429,674247,210127,221202,2400,552034,101557,578465,543384,170328,390947,592185,896401,38537,814139,294537,230303,825819,411878,821027,981817,328905,269036,909004,213881,56406,957947,815357,622522,520201,767171,347395,362607,23404,692764,151562,707729,623915,797439,175599,333568,72407,897545,281390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]