SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041714 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041714 [ RunTime:0.003971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287824,541987,447313,442831,214434,383778,747091,78772,1020927,209217,154264,579863,11498,62802,669767,1026980,623424,7692,81468,972648,787255,158038,555357,882818,669291,171753,121448,507706,890420,1046252,845220,901656,747425,390964,218282,366601,339450,126246,952580,945730,503264,985664,112550,326609,762315,167563,669812,308804,820653,485012,18295,657212,788246,355631,85117,144112,1022032,905373,766752,468036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]