SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498915 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498915 [ RunTime:0.001751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (752239,506978,1013574,153880,986764,891039,702158,1036210,114112,925681,761812,207017,295949,222350,75302,22818,841134,46261,131164,571294,28753,804748,19308,330177,46471,31660,316324,335678,728798,1006809,868425,491482,708333,467853,467361,980850,189003,713368,879257,475395,653501,502068,804588,123045,202513,488473,570049,572226,80672,519378,212655,402277,955968,298727,346881,437481,850598,986751,350914,886194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498915 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498915 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]