SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578758 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578758 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52780,501951,693054,608548,1042523,378884,785655,658558,792092,121965,935035,315189,751483,547807,935561,198841,657810,386669,593023,447402,554082,213846,229910,156155,424194,317087,808031,936564,831690,385086,261695,152038,923164,953281,930404,972291,525275,515915,767513,134195,916144,177871,392420,68134,271863,48306,497748,89757,422252,806438,988973,28218,989403,135109,398001,848561,186180,886188,64367,881587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]