SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578218 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578218 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418366,282493,358517,946774,1028839,62168,532135,400328,227753,557380,575896,510438,271002,64350,617175,1019200,308427,916361,449019,1041414,292129,703364,840507,186669,763303,563475,35082,811922,913961,933345,450510,391737,297013,501990,1042482,1001814,819032,412375,916197,307015,408221,1044094,672988,201867,319297,682205,772676,881286,207976,844058,332266,960967,181094,485053,363693,261433,998407,799975,216134,905013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]