SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028393 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028393 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768916,695719,880281,957299,1042524,71440,364149,365281,431882,600557,889800,789105,269013,466034,576978,894732,195828,777606,453859,978273,500391,247536,671270,866888,684637,665479,314366,221193,806920,871137,1023874,380573,858274,397240,407296,121692,320605,917704,149320,378616,802946,1047868,130250,55012,676173,874338,760520,1020953,674343,105553,773422,256301,617897,134173,505546,841278,996769,785126,820164,796939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001294s ]