SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001587s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385318 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385318 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402594,36695,551463,155463,859458,144193,128682,360722,1001360,883057,437358,670700,290412,966352,740983,268996,616904,314987,538740,414458,147199,853897,847057,333917,950159,850255,539089,252223,257271,682135,160079,406571,213482,142621,866016,229408,289482,584775,941785,593069,59845,653209,775479,50862,447978,542862,337689,137506,504708,678101,757208,933422,533026,131927,458566,758495,10535,237667,312561,322941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]