SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536504 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536504 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190748,493160,892221,384573,707441,447551,1018144,536465,909310,611749,516376,871098,340459,997782,72453,281245,92440,106130,612518,424369,407592,379171,715770,314159,660214,306455,717977,353435,287967,484600,889250,179019,967266,867046,607900,640481,155867,964415,779125,558071,650882,715901,367528,778648,21624,563518,964606,484312,962097,447845,850583,646246,642986,1042582,275370,591354,492119,255406,910487,151127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]