SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5734 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5734 [ RunTime:0.001482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625521,322903,49040,253695,445719,207453,313656,113062,382284,401969,76372,567229,285817,805062,256878,997625,171510,359405,836156,978663,386251,61591,766971,681044,541541,18260,135824,666065,687989,464982,266029,138762,1040232,951476,108212,109703,360351,29195,254583,472117,469430,437977,760237,425321,901097,202527,654709,841548,39419,994039,834542,147974,532919,54190,547390,473525,659898,972828,288607,69025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5734 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5734 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]