SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427971 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427971 [ RunTime:0.002550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586692,1014189,440912,100306,924604,267063,705802,208327,140525,796963,1010186,123050,379267,768756,585375,509326,606607,194569,808680,385174,327952,355703,425758,279253,1025182,464602,309698,681413,821421,138410,301573,533862,544938,189815,419301,257055,479542,101929,690308,621340,1003418,827115,303985,452953,363238,18346,173731,419954,613864,181392,459736,374922,211298,414633,115329,274353,71858,737198,529363,811105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]