SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454071 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454071 [ RunTime:0.004167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583296,481713,339611,421675,1008247,190906,921407,427156,787657,153193,115413,1034919,489029,801842,564451,41902,18485,246207,639324,471625,368931,919315,745979,913005,107303,1048336,415984,952624,94925,939382,994976,576764,910549,467166,445176,515729,793225,131175,665519,15629,518729,959464,485917,864895,828755,678385,134506,119062,634144,560459,392919,1007575,189653,381538,862342,345433,438161,13884,174831,164660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]