SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840018 LIMIT 1 [ RunTime:0.003716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840018 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664527,410372,29825,975249,117249,486856,797947,17743,746553,174957,25416,434803,131371,750679,409040,594352,685328,895900,724788,899218,108850,114148,736124,676834,956602,273110,248312,839862,441167,146602,483412,1002340,328467,23468,960172,184428,134416,998959,93207,846854,697943,908774,41250,154934,925956,729927,977433,170136,511324,350862,1042945,541503,536219,482788,195803,199697,980952,909612,663523,83734) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000898s ]