SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284169 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284169 [ RunTime:0.003239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476361,1010140,707150,284877,465325,240206,47592,1041589,928912,300003,799685,646592,267505,290923,745247,255639,35807,26791,925286,560035,1013984,186213,997658,543698,115172,458373,582699,121563,870105,46321,389357,761651,819890,839315,375029,638337,360562,407383,110092,461912,183819,1015172,893688,428036,505170,603781,691968,442808,44281,747192,976642,627126,450968,538919,210450,836255,1024208,417887,1020574,144156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000770s ]