SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503544 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503544 [ RunTime:0.002596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206943,962168,577140,943999,701677,484778,72632,353932,902887,699145,62695,867044,841500,270041,930244,244837,953707,627601,209222,995476,185878,1021665,872904,689366,636609,393838,611968,957257,236093,980885,453000,425170,765773,407948,426162,617853,974897,66626,659764,401553,338708,238509,765640,502452,214414,772821,500063,777081,1042495,563529,1032845,828969,641114,21914,665392,967634,742755,252166,102046,275349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]