SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043766 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043766 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103983,366395,429270,651444,187050,862581,150859,440897,546155,280721,141869,818502,740149,338268,482013,504395,810224,281128,982496,569530,1039411,939855,1001137,31343,266023,600512,847017,425500,101764,822192,131218,679751,153799,61189,429904,412500,120937,776830,315016,61727,438767,928803,517729,427993,983099,781572,707685,74174,360338,136280,386521,396120,915574,178989,799765,449571,682101,553098,138325,428271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001747s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]