SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047061 LIMIT 1 [ RunTime:0.005560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047061 [ RunTime:0.002970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89165,405199,314606,810383,990964,244150,565185,391194,626283,621844,529104,1047215,786741,1011191,280836,496247,931300,1001084,1041799,9690,937568,825087,699600,74599,66090,456794,157932,609656,799784,241822,508504,403403,840787,537596,265737,908205,88061,609302,621035,260558,1035714,1011428,27041,580893,251049,189343,563334,249932,325948,685172,21642,30115,971521,755801,1032438,298271,810336,846472,969182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]