SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417815 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417815 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478251,841333,538665,1004096,796792,471532,995918,262381,254003,755388,844752,999382,225512,322328,452267,609195,43068,896895,879458,270855,862253,482550,1022334,680065,733207,344811,838525,515471,410919,467772,379551,657652,152651,339991,835842,641934,1023758,808450,988512,316787,411292,1002195,616462,871920,371532,860491,1000947,663757,402931,144914,921497,796820,918779,999062,696335,50072,715690,432499,704755,365336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]