SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413763 LIMIT 1 [ RunTime:0.001106s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413763 [ RunTime:0.001404s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991750,238427,166843,230113,387919,970261,593130,795417,572176,524481,475316,718896,305445,509002,656266,621399,166285,513867,503353,824627,314257,255058,97150,292843,1044012,860345,990947,377891,781039,652885,1048068,494690,163506,634713,194582,600768,618260,472452,248665,826442,464517,126664,412132,87293,158874,59764,497214,806787,44640,795636,50361,46894,466846,429971,7140,635971,1030104,842117,971409,265802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]