SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501538 LIMIT 1 [ RunTime:0.005536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501538 [ RunTime:0.001418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (750792,163717,332668,314127,71966,970609,185784,135120,976888,473096,561283,1002904,1007213,172753,40447,945890,166154,717262,845920,508667,431081,727500,960132,926739,156543,524454,422245,74031,886378,217579,623099,889112,512078,842686,895908,938098,830606,459519,589660,973455,598378,487554,1038179,803597,612837,93639,1014807,319021,625853,234614,377212,914217,289812,128273,38429,826526,165969,338614,208018,798976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]