SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 164690 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 164690 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005574,710042,258899,1022258,147097,599231,64063,225442,575336,551910,476839,733236,799211,783002,745197,18078,499893,934123,793656,598935,476988,159532,941005,463346,890241,1002132,800029,126082,726890,601089,832640,723558,13825,325891,1013681,590568,446428,249572,463698,585235,457918,188120,720447,208471,307380,708257,823453,174732,963352,722102,309160,388167,852668,921266,462958,209456,459904,767871,158765,456659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 164690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 164690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]