SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519381 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519381 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (737149,558568,1032472,926557,184980,303311,562243,1036769,725296,698722,220534,685725,705959,786213,467696,725256,548036,429083,361036,821496,804486,56464,163327,946088,270213,125890,770230,65220,266743,583314,184558,644230,818659,580338,653627,1039417,240469,864492,62364,955220,951853,848195,122944,298504,459330,947235,41665,927411,970243,5868,552483,70961,641584,726226,125298,433141,288594,537507,103530,848413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]