SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428531 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428531 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1773,475575,101861,158169,255033,180401,1045303,699450,1045572,716007,954703,454554,512660,930374,881570,673663,380346,68582,324269,998933,41023,843551,986238,115639,582616,372326,996882,173821,442867,1027302,564407,592972,975102,343353,717329,376609,773370,463135,331260,60234,991378,671597,127760,402699,867790,78204,7373,419822,29824,302127,369596,773893,574436,459596,491020,248561,865941,970297,523507,359353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]