SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018991 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018991 [ RunTime:0.001922s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91742,311953,936247,567392,733814,392356,772026,617034,858135,496628,1024471,850910,465575,479055,1010644,217721,817208,911564,771542,547098,743305,476557,200165,726507,323483,219887,882780,899112,425704,711048,540815,854024,449572,187992,507306,886549,572108,124021,238303,438441,88928,771887,993984,32155,406331,541567,985761,27064,700185,653876,711442,885246,157984,468340,934915,575111,427126,122485,36642,340567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000361s ]