SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317860 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317860 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888428,103125,352273,258688,875957,151927,316319,977185,344199,808610,231227,973419,622847,561718,261455,90052,841968,785350,621506,580936,107471,367693,1037884,758147,12417,376237,595475,184125,147032,508950,945094,118179,617769,671391,933743,556622,515393,344890,120939,357669,134808,471643,227085,582017,721988,278252,346408,792129,495243,141734,697502,505817,523398,695751,719734,336487,775500,295863,100171,76947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]