SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402886 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402886 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734571,968158,328411,928408,194190,27909,367573,386661,805237,314603,929120,315431,814655,721784,133226,332051,285358,878848,587384,743549,1022653,347729,49229,268425,82466,463932,967958,921005,93330,1040498,62884,172488,492883,392266,584238,184756,998146,116547,899097,350885,39152,61688,564503,58238,1035767,277688,548265,264837,215532,227229,916703,983607,374451,54045,284856,472364,330615,88578,25341,970091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402886 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402886 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]