SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039031 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039031 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421654,127868,561282,151440,759078,452215,1035443,63884,855953,162948,783340,220040,34862,467939,213554,829311,490784,220782,735833,850676,389046,797518,665318,609641,305314,435034,472944,460238,631873,542973,242489,457561,195594,208930,33752,673092,94732,722027,630795,1018931,810396,725051,135454,127929,138334,141541,531589,509281,997675,840311,964247,793221,383859,88624,881665,389256,544750,883164,119445,703744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002222s ]