SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517612 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517612 [ RunTime:0.001791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523465,647102,163591,154840,1045474,768901,379422,475851,597148,96078,226745,1033481,575758,560866,78458,293187,865896,1001902,41380,458915,2752,605988,794964,772144,1010029,981558,114668,909282,992638,185598,489346,433191,635688,215885,351301,361010,1038922,62589,690340,142842,988346,885155,869598,1038996,763065,666341,461116,338964,202894,1024301,879308,871091,442865,836674,913448,192460,223621,929098,782403,759045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]