SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516804 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516804 [ RunTime:0.005163s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135123,387315,651532,346035,704063,882226,851450,197745,108575,407323,561533,882456,859080,816577,413024,481253,911506,128966,134641,141908,708321,502031,518833,816545,924604,324400,330165,547049,804904,708027,518292,462401,871956,862592,745315,980372,701200,693817,748593,938920,609938,791584,617928,733993,125204,93206,60541,141565,552574,775962,952711,459477,680518,57290,86288,819069,798621,553113,913637,670876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]