SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450098 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450098 [ RunTime:0.003797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273975,366020,285582,87501,970828,595561,690150,381414,498240,424479,98226,320565,466302,808362,476062,837025,214474,975805,1012818,1048491,517896,916840,808275,914459,575374,661663,251429,302011,590449,974304,773535,237879,307241,198464,911667,424450,883419,830656,863243,103327,546814,318265,236407,25289,564231,960480,787021,225366,787644,650999,918845,86783,540308,611757,927995,550448,362463,205056,454134,611402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]