SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486267 LIMIT 1 [ RunTime:0.000546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486267 [ RunTime:0.005556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (912952,247035,256509,466333,548919,491611,46773,531812,137147,976239,553505,728272,429724,747037,381548,540831,798675,337674,1025644,792396,269029,390495,431034,1027622,872665,671661,894414,799725,688911,253967,680567,877634,203491,798209,465324,500808,721547,573932,1024456,34727,128907,472050,358836,37401,355932,1012332,832514,41807,302349,456855,24278,1036900,371862,165968,391129,511129,884901,377799,858774,227139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]