SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319894 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319894 [ RunTime:0.002588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370513,658438,847508,170578,530461,241253,303077,935442,757908,649444,68292,399495,695445,277802,139930,557873,166139,936901,325464,675373,450844,462549,145281,643488,547183,603346,362492,722192,484288,446186,771571,118281,1022521,260417,903567,771895,504724,278792,658544,555259,339869,574341,200974,822148,1030103,645737,655513,578632,891413,86308,515182,916438,278908,506299,518540,296348,270745,551552,745929,182952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]