SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502410 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502410 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (158133,253619,626148,899401,703938,141941,854988,236964,426375,205217,774774,99101,899894,226798,6128,234033,423818,955380,273666,740645,620673,937449,1006092,289316,485624,81247,1020161,4564,955841,204629,939661,287757,616723,61983,531864,549412,345608,272624,232101,152540,679691,191620,98415,917521,110701,188323,868667,760202,938031,209103,539474,388654,156160,552480,637179,588771,354222,129434,647694,413016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]