SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 918911 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 918911 [ RunTime:0.002086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62186,566583,209292,437805,697449,721122,871302,146166,357813,602374,629496,315690,1038676,962812,248330,1034409,719938,405477,470463,156743,832570,469746,841734,110531,828738,112502,81200,683001,51620,573825,529763,619159,758830,59186,813077,66398,987438,478024,347086,1034849,174776,205137,473292,455367,849727,112326,220856,676439,104141,597280,306701,50414,654698,517138,587301,752955,574764,821403,50581,424387) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 918911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 918911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]