SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415099 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415099 [ RunTime:0.005182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146403,497695,895539,23108,545895,965648,104555,1007779,735663,590341,542664,919049,176714,370010,645048,114730,214980,602311,526604,855112,37604,1004054,297700,185560,1013067,256154,100204,760202,134050,897580,146013,856636,409948,376199,94085,850194,987908,16114,358725,324715,434944,649376,1001180,147396,555168,995836,65409,229208,438769,342509,868577,310120,516705,411057,782723,660055,108364,155152,576009,134057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]