SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200889 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200889 [ RunTime:0.002019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450740,510308,880957,604009,260970,762147,869419,839532,1043610,532608,563666,431298,1034017,229725,188715,384331,313644,866309,390147,911091,967472,114052,955789,211435,679130,912960,261731,540009,595696,791580,878077,70603,10068,1033517,871668,715719,246273,367800,15394,358890,675639,406910,367437,957100,583578,377669,804125,567675,102979,883566,608766,261129,980894,298552,127733,345374,152748,106579,126197,408889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200889 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200889 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]