SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 370728 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 370728 [ RunTime:0.001642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5213,1003491,1034985,91875,898171,237993,348480,254677,594181,490623,869163,392002,43493,420629,835120,764499,462128,126345,986187,837629,542023,248330,380388,911280,259807,651517,875,115287,366502,1043101,268135,135431,887111,63406,654941,907962,847627,217963,261362,441305,724526,300159,893965,1017817,438549,110042,770569,816775,1003133,562456,101129,131960,142855,548040,528307,548752,560628,489101,428691,219295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 370728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 370728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]