SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 628013 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 628013 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137304,513920,633543,635880,818900,8667,710446,219026,916061,833891,536762,674534,404127,492690,847516,889330,83372,754919,462896,862081,845499,931822,386101,720291,836202,1031353,352433,303949,976015,719479,652000,48779,971169,1022078,811575,613307,93557,481341,987329,694650,913469,947462,789928,2693,410447,100189,684951,765849,929499,884810,163543,313747,693808,264741,443120,87049,743715,318322,445176,992222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 628013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 628013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003840s ]