SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496937 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496937 [ RunTime:0.004576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324872,499233,615791,630952,520809,1018642,223512,95398,249406,289014,181529,128059,924258,481795,645201,992868,295416,919854,459049,35968,1011824,398783,576207,543554,268754,196335,611147,743721,492287,957487,793674,704952,109111,503573,335895,754956,948336,349680,358902,368651,299394,921912,212227,1024590,808320,645822,978291,681344,296672,731532,622237,851114,557656,810634,844611,77788,252973,437315,1010387,904967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496937 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496937 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]