SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434951 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434951 [ RunTime:0.007189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566881,133134,72832,604541,572538,897394,16263,446374,603,378173,60446,352793,232344,927540,348127,660151,871657,58987,693607,198192,593148,535804,797975,994506,315217,1009166,443492,637382,66825,363366,517878,797014,684517,890775,459028,337343,531076,442188,502915,125179,279877,548028,78022,17297,734512,105725,107597,372046,169732,531791,37344,551755,762697,485480,1008137,455324,502588,512977,429984,1013991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]