SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427829 LIMIT 1 [ RunTime:0.000587s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427829 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651991,928191,457681,216563,373855,565074,714518,710328,659696,115406,94105,330012,296860,48180,143344,368350,836090,851391,442265,656260,257854,553740,772227,175335,796928,725835,56348,890811,70278,1035566,884827,807253,682011,509189,992578,882692,1019827,275813,206635,202756,872663,570626,766494,878950,729648,896191,267214,261089,748432,301935,992071,747328,491365,1021746,590446,158981,688539,854624,442684,391958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001559s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]